Film_Locations_in_San_Francisco

Data source: data.sfgov.org

19 rows where Actor 1 = 265

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Locations, Fun Facts, Production Company, Distributor, Director, Writer, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
127 127 Bicentennial Man 33 1999 26 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
128 128 Bicentennial Man 33 1999 26 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
129 129 Bicentennial Man 33 1999 26 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
130 130 Bicentennial Man 33 1999 26 Postcard Row, Alamo Square, Hayes Valley The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
131 131 Bicentennial Man 33 1999 26 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
503 503 Fathers' Day 93 1997 8     Northern Lights Entertainment 67 Columbia Broadcasting System 22 Ivan Reitman 84 Lowell Ganz 79 Robin Williams 265 Billy Crystal 73  
520 520 Flubber 97 1997 8 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Walt Disney Pictures 70 Buena Vista Pictures 25 Les Mayfield 88 Samuel W. Taylor 89 Robin Williams 265 Marcia Gay Harden 77  
705 705 Jack 137 1996 43     American Zoetrope 92 Buena Vista Pictures 25 Francis Ford Coppola 127 James DeMonaco 127 Robin Williams 265 Diane Lane 112  
905 905 Mrs. Doubtfire 170 1993 46 1200 Washington Street at Taylor Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
906 906 Mrs. Doubtfire 170 1993 46 Hancock School (940 Filbert Street)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
907 907 Mrs. Doubtfire 170 1993 46 Danilo's Bakery (Green Street & Bannam Place)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
908 908 Mrs. Doubtfire 170 1993 46 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
909 909 Mrs. Doubtfire 170 1993 46 520-522A Green Street at Grant Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
910 910 Mrs. Doubtfire 170 1993 46 516 Green Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
911 911 Mrs. Doubtfire 170 1993 46 100 Embarcadero Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
1010 1010 Patch Adams 187 1998 18 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1011 1011 Patch Adams 187 1998 18 Sheraton Palace Hotel (639 Market Street) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1012 1012 Patch Adams 187 1998 18 Presidio (Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1581 1581 What Dreams May Come 299 1998 18 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 Vincent Ward 243 Ron Bass 259 Robin Williams 265 Cuba Gooding, Jr. 232  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 109.681ms · Data source: data.sfgov.org